Sql="Select distinct addtimes From guestbook where u_id="&session("u_id")&" order by addtimes desc

来源：百度知道编辑：UC知道时间：2024/06/18 10:07:44

Sql="Select distinct addtimes From guestbook where u_id="&session("u_id")&" order by addtimes desc"

想实现按日期查询留言，但留言时间里带着时间呢，怎么把时间去了啊？

取DATE或者取年月日
如:
Sql="Select distinct Date(addtimes) From guestbook where u_id="&session("u_id")&" order by addtimes desc"

or

year(addtimes)&"-"&month(addtimes)&"-"&day(addtimes)

日期应该是固定位置吧？用right或者left截取

" sql=sql & sqlstr(NewsTitle) & " sql=sql & " order by m_id DESC" sql="select * from user" sql = sql&"content like '%"&keywordarray(0)&"%'"中%什么意思 sql = sql + request("txtxh") + ","无法添加到数据库 sql="select * from问题 sql="select * from sg where sql="select * from……" sql = "Select top 5 * from news" 请问sql = "update userinf set "什么意思